package com.shlh.saas.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shlh.saas.entity.Announcement;
import com.shlh.saas.entity.CustomerService;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface AnnouncementMapper extends BaseMapper<Announcement> {

    @Select("SELECT announcement_content FROM announcements where status = #{status} order by announcement_sort")
    List<String> selectAnnouncementsList(@Param("status") Long status);

    @Select("SELECT announcement_content_en FROM announcements where status = #{status} order by announcement_sort")
    List<String> selectAnnouncementsEnList(@Param("status") Long status);
}
